home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 9 / developer source - volume 9.iso / dbmsa / aug96 / kimbf103.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  39KB  |  326x308  |  4-bit (16 colors)
Labels: text | screenshot | font | menu | number
OCR: Retail Sales Time Fact Table Dimension Product Day Key Day Key 2. More granular Dimensioni Product Key dimension Date (if a subset Store Week of original Dimension Store Key granularity Vendor Vendor Key Fiscal Period Dimension Dollars Sold Holiday Flag 3. New Number Sold Weekend Flag dimension 1. New attributes Dimersion customer Count Season 4. New Facts Figure 3. A star join database can be extended in many ways without affecting existing applications. This diagram shows how 1) new dimensions, 2) more granular dimensions, 3) new dimension attributes, and 4) new facts can be added.